package com.survey.project.research.domain.vo;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.survey.framework.aspectj.lang.annotation.Excel;
import com.survey.framework.web.domain.BaseEntity;
import lombok.Data;
import org.apache.commons.lang.builder.ToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;

import java.util.Date;

/**
 * 客户导入excel
 *
 * @author survey
 * @date 2021-05-20
 */
@Data
public class ConsumerExcelVo {
    private static final long serialVersionUID = 1L;

    /**
     * seq_sv_consumer.nextval
     */
    private Long consumerId;

    /**
     * 客户姓名
     */
    @Excel(name = "客户姓名")
    private String consumerName;

    /**
     * 电话号码
     */
    @Excel(name = "电话号码")
    private String mobile;

    /**
     * 性别(0-女,1-男)
     */
    @Excel(name = "性别(女,男)",readConverterExp = "0=女,1=男")
    private String sex;

    /**
     * 省份
     */
    @Excel(name = "省份")
    private String province;

    /**
     * 城市
     */
    @Excel(name = "城市")
    private String city;

    /**
     * 生日
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "生日", width = 30, dateFormat = "yyyy-MM-dd")
    private Date birthday;

    /**
     * 婚姻状况(0-未婚,1-已婚)
     */
    @Excel(name = "婚姻状况(未婚,已婚)",readConverterExp = "0=未婚,1=已婚")
    private String maritalStatus;

    /**
     * 学历
     */
    @Excel(name = "学历")
    private String education;

    /**
     * 问卷编号
     */
    @Excel(name = "问卷编号")
    private String questionnaireNo;

    /**
     * vin号
     */
    @Excel(name = "vin号")
    private String vin;

    /**
     * 产品编号
     */
    @Excel(name = "产品编号")
    private String productNo;

    /**
     * 产品名称
     */
    @Excel(name = "产品名称")
    private String productName;

    /**
     * 发动机序列号
     */
    @Excel(name = "发动机序列号")
    private String engineNo;

    /**
     * 生产日期
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "生产日期", width = 30, dateFormat = "yyyy-MM-dd")
    private Date productionDate;

    /**
     * 录入经销商名称
     */
    @Excel(name = "录入经销商名称")
    private String inputDealerName;

    /**
     * 经销商名称
     */
    @Excel(name = "经销商名称")
    private String dealerName;

    /**
     * 经销商类型
     */
    @Excel(name = "经销商类型(数字)")
    private String dealerType;

    /**
     * 购车经历
     */
    @Excel(name = "购车经历")
    private String carBuyExperience;


}
